﻿DELIMITER //

--
--
CREATE TABLE IF NOT EXISTS ZeusPicking
(
  -- ID
  --
  ID INTEGER AUTO_INCREMENT PRIMARY KEY,

  -- Azonosító
  --
  Code VARCHAR(20) NOT NULL,

  --
  --
  PartnerName VARCHAR(256) NOT NULL,

  -- User
  --
  UserID INTEGER NULL,

  FOREIGN KEY (UserID) REFERENCES ZeusUser (ID),

  -- Állapot
  --
  -- 'O' Opened
  -- 'C' Closed
  --
  Status VARCHAR(1) NOT NULL

) ENGINE = InnoDB
//


--
--
CREATE UNIQUE INDEX iCode ON ZeusPicking (Code)
//
